package com.zz.dao;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.zz.entity.Types;

public interface TypesDao {
	//查询所有
	@Select("select * from types")
	public List<Types> Typesquery();
	//查单
	@Select("select * from types where id=#{id}")
	public Types TypesqueryById(int id);
	//删除
	@Delete("delete from types where id=#{id}")
	public void Typesdel(int id);
	//修改
	@Update("update types set name = #{name} ,num = #{num} where id = #{id} ")
	public void typesupdate(Types types);
}
